﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="DB.aspx.cs" Inherits="DEMI_webapp.DB" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
            Caption="Historia" DataKeyNames="id" 
            DataSourceID="SqlDataSource_Historia">
            <Columns>
                <asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" 
                    ReadOnly="True" SortExpression="id" />
                <asp:CheckBoxField DataField="operacja" HeaderText="operacja" 
                    SortExpression="operacja" />
                <asp:BoundField DataField="data" HeaderText="data" SortExpression="data" />
                <asp:BoundField DataField="magazynier" HeaderText="magazynier" 
                    SortExpression="magazynier" />
                <asp:BoundField DataField="ilosc" HeaderText="ilosc" SortExpression="ilosc" />
                <asp:BoundField DataField="kapelusz" HeaderText="kapelusz" 
                    SortExpression="kapelusz" />
                <asp:BoundField DataField="klient_id" HeaderText="klient_id" 
                    SortExpression="klient_id" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource_Historia" runat="server" 
            ConnectionString="<%$ ConnectionStrings:conString %>" 
            SelectCommand="SELECT * FROM [Historia]"></asp:SqlDataSource>
        <br />
        <br />
        <asp:GridView ID="GridView3" runat="server" AutoGenerateColumns="False" 
            Caption="Klienci" DataKeyNames="id" 
            DataSourceID="SqlDataSource_Klienci">
            <Columns>
                <asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" 
                    ReadOnly="True" SortExpression="id" />
                <asp:BoundField DataField="nazwa" HeaderText="nazwa" SortExpression="nazwa" />
                <asp:BoundField DataField="imie" HeaderText="imie" SortExpression="imie" />
                <asp:BoundField DataField="nazwisko" HeaderText="nazwisko" 
                    SortExpression="nazwisko" />
                <asp:BoundField DataField="adres" HeaderText="adres" SortExpression="adres" />
                <asp:BoundField DataField="nip" HeaderText="nip" SortExpression="nip" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource_Klienci" runat="server" 
            ConnectionString="<%$ ConnectionStrings:conString %>" 
            SelectCommand="SELECT * FROM [Klienci]"></asp:SqlDataSource>
        <br />
        <asp:GridView ID="GridView4" runat="server" AutoGenerateColumns="False" 
            Caption="Magazynierzy" DataKeyNames="id" 
            DataSourceID="SqlDataSource_Magazynierzy">
            <Columns>
                <asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" 
                    ReadOnly="True" SortExpression="id" />
                <asp:BoundField DataField="imie" HeaderText="imie" SortExpression="imie" />
                <asp:BoundField DataField="nazwisko" HeaderText="nazwisko" 
                    SortExpression="nazwisko" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource_Magazynierzy" runat="server" 
            ConnectionString="<%$ ConnectionStrings:conString %>" 
            SelectCommand="SELECT * FROM [Magazynierzy]"></asp:SqlDataSource>
        <br />
        <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" 
            Caption="Kapelusze" DataKeyNames="id" 
            DataSourceID="SqlDataSource_Kapelusze">
            <Columns>
                <asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" 
                    ReadOnly="True" SortExpression="id" />
                <asp:BoundField DataField="nazwa" HeaderText="nazwa" SortExpression="nazwa" />
                <asp:BoundField DataField="kolor" HeaderText="kolor" SortExpression="kolor" />
                <asp:BoundField DataField="cena" HeaderText="cena" SortExpression="cena" />
                <asp:BoundField DataField="material" HeaderText="material" 
                    SortExpression="material" />
                <asp:BoundField DataField="ilosc" HeaderText="ilosc" SortExpression="ilosc" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource_Kapelusze" runat="server" 
            ConnectionString="<%$ ConnectionStrings:conString %>" 
            SelectCommand="SELECT * FROM [Kapelusze]"></asp:SqlDataSource>
        <br />
        <asp:GridView ID="GridView5" runat="server" AutoGenerateColumns="False" 
            Caption="Zamówienia" DataKeyNames="id" 
            DataSourceID="SqlDataSource_Zamowienia">
            <Columns>
                <asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" 
                    ReadOnly="True" SortExpression="id" />
                <asp:BoundField DataField="adres" HeaderText="adres" SortExpression="adres" />
                <asp:BoundField DataField="odbior" HeaderText="odbior" 
                    SortExpression="odbior" />
                <asp:BoundField DataField="id_klienta" HeaderText="id_klienta" 
                    SortExpression="id_klienta" />
                <asp:BoundField DataField="data_zlozenia" HeaderText="data_zlozenia" 
                    SortExpression="data_zlozenia" />
                <asp:BoundField DataField="data_zrealizowania" HeaderText="data_zrealizowania" 
                    SortExpression="data_zrealizowania" />
                <asp:BoundField DataField="cena" HeaderText="cena" 
                    SortExpression="cena" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource_Zamowienia" runat="server" 
            ConnectionString="<%$ ConnectionStrings:conString %>" 
            SelectCommand="SELECT * FROM [Zamowienia]"></asp:SqlDataSource>
        <br />
        <asp:GridView ID="GridView6" runat="server" AutoGenerateColumns="False" 
            Caption="Zamówione kapelusze" DataKeyNames="id" 
            DataSourceID="SqlDataSource_ZamowioneKapelusze">
            <Columns>
                <asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" 
                    ReadOnly="True" SortExpression="id" />
                <asp:BoundField DataField="id_zamowienia" HeaderText="id_zamowienia" 
                    SortExpression="id_zamowienia" />
                <asp:BoundField DataField="id_kapelusza" HeaderText="id_kapelusza" 
                    SortExpression="id_kapelusza" />
                <asp:BoundField DataField="ilosc_kapeluszy" HeaderText="ilosc_kapeluszy" 
                    SortExpression="ilosc_kapeluszy" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource_ZamowioneKapelusze" runat="server" 
            ConnectionString="<%$ ConnectionStrings:conString %>" 
            SelectCommand="SELECT * FROM [Zamowione_kapelusze]"></asp:SqlDataSource>
    </div>
    </form>
</body>
</html>
